Month Format summation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi. I have this excel spreadsheet as the followings :
Column A1 = 3 (in number)
Column B1 = 1/4/2006
C1 = 1/1/2006 (answer)

I need to find out what is the previous 3 months before 1/4/2006 in C1. Do
I have to format Column A1 (3) in the month format as it is just a number.

Thank you in Advance !!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Countifs with different restrictions 1
How to set the value to zero if it negative after the substract 5
Excel Help with dates 2
sum working hours each month (sum hours in the last row for a monthin a table with dates) 3
Merging cells and formats 8
setting cell values based on a 3rd cell 4
Extract Number of Weekdays (Mon-Fri) & Saturdays for a particular Month/Yr 13

Back
Top