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...

   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. Conditional formatting to highlight if its over a year.

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

   Enter the formula =EDATE(TODAY(),-11) in the box next to it. 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.

5. 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 ...

6. Apple Mail and Exchange - Microsoft Community

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

   Harassment is any behavior intended to disturb or upset a person or group of people. Threats include any threat of violence, or harm to another.

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...

   I have tried many of the older coding and ihasnt worked ex using a format to change color by going to home-> conditional formatting ->fomat cell with this value --> =TODAY-335 to create red or =TODAY()-335 to create red etc. please help

9. 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

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. Formula to calculate tenure (Years & Months) - MrExcel

    www.mrexcel.com/board/threads/formula-to-calculate-tenure-years-months.1230557

    =DATEDIF(G2,NOW(),”Y”)& ”years", “&DATEDIF(G2,TODAY(),”YM”)& ”months“ I am using the above formula to calculate the tenure date in years and months for...