enow.com Web Search

Search results

1. Results from the WOW.Com Content Network

2. Formula in Excel to add & subtract 18 months to/from a date

   answers.microsoft.com/en-us/msoffice/forum/all/formula-in-excel-to-add...

   =date(year(a1),month(a1)-18,day(a1)) both formatted as Date or a date-related Custom format. The key difference depends on how you want to handle the case when A1 is Mar 31 2011, for example.

3. Formula to return date of 18 months from today's date

   www.mrexcel.com/board/threads/formula-to-return-date-of-18-months-from-todays...

   438. Feb 7, 2008. #1. Is there a formula that I can use in Excel that will return the exact date of 18 months ago (today). I had a formula that would return 18 months End of Month date by using. =eomonth (today (),-18) but I need the exact date of 18 months ago from today.

4. IF formula to show if something is older than 6 or 12 months

   www.mrexcel.com/board/threads/if-formula-to-show-if-something-is-older-than-6...

   I need a formula for my “age column” that will tell me if an item is current, more than 6 months old, or more than 12 months old : Using the day the sheet is opened (so always “today”..... If (cell with date in) is less than 6 months older than today “Current”. If (cell with date in) is more than 6 months older than today “6 ...

5. Conditional formatting to highlight if its over a year.

   answers.microsoft.com/en-us/msoffice/forum/all/conditional-formatting-to...

   Click Format... Specify the desired formatting, then click OK twice. This rule will highlight dates 11 months before today or older. Repeat the above steps, but with =EDATE (TODAY (),-12) and different formatting. This rule will highlight dates 12 months (1 year) before today or older. It will override the first rule if applicable.

6. Unrecognized database format path/filename.mdb

   answers.microsoft.com/en-us/msoffice/forum/all/unrecognized-database-format...

   I have an Access 10 database that I have been working on for over 18 months. Today, when running a single table query, data was retrieved like always. And then, within 30 seconds or so, I get the

7. IF Statement Required - if Date is greater than 12 months

   www.mrexcel.com/.../if-statement-required-if-date-is-greater-than-12-months.589498

   Hi All, In column A I have dates. In column B I need a formula that says true of false if the date is greater than 12 months ago.

8. Change cell colors based on date (conditional formatting)

   answers.microsoft.com/en-us/msoffice/forum/all/change-cell-colors-based-on...

   For Green Status: - Enter this formula and select Green color from Format button. =TODAY ()-DATE (YEAR (A2)+1,MONTH (A2),DAY (A2))>=61. For Orange Status: - Enter this formula and select Orange color from Format button. =TODAY ()-DATE (YEAR (A2)+1,MONTH (A2),DAY (A2))>=31. For Red Status: - Enter this formula and select Red color from Format ...

9. Apple Mail and Exchange - Microsoft Community

   answers.microsoft.com/en-us/outlook_com/forum/all/apple-mail-and-exchange/c29d...

   In reply to LanceCai_MSFT2205's post on March 9, 2016. 1) exchange. 2) it happened simultaneously on my mac apple mail and iphone apple mail (worked fine monday evening and did not work on tuesday morning; my company and i did not do anything to email; my colleagues have not had any problems) 3) see attached. one screenshot of trying to set up ...

10. Automatically calculating the MOST RECENT 3 month average...

    answers.microsoft.com/en-us/msoffice/forum/all/automatically-calculating-the...

    I have a spreadsheet that has empty cells for the next 18 months that needs to be filled in by a colleague. As he fills in the data from month to month, I'd like a cell to calculate the latest 3 month average , without having to manually go in every single time and change the cell references.

11. Rolling 12 month forecast - backwards | MrExcel Message Board

    www.mrexcel.com/board/threads/rolling-12-month-forecast-backwards.1173458

    Help, I'm looking for a formula to calculate a rolling backwards forecast with actuals, based on a date field to calculate a rolling 12 month total. I'd like to automate it based on the current date so should take last twelve months from today. For example: Month1 Month 2 Month 3..... to month 12 and then next month add in month 13