need formula for sequential daily dating

  • Thread starter Thread starter peta
  • Start date Start date
P

peta

I'm creating a time sheet for which I do not want to have to manuall
enter the next days date, OK to start with a date but then use
formula to do the next cells sourcing from the previous cell.

To look something like this:

21/01/2004 (manual entering OK)
22/01/2004 (require formula sourcing from above date
23/01/2004 (as above... etc etc)*(B)21(/B)
 
Peta,

Assuming your date 21/01/2004 is in cell A1 in cell A2 just use =A1+1

In Excel a date is just a number (1-1-1900 =1 ; 2-1-1900 =2 etc.) so you can
do normal calculations with them.
Excel takes care of leap years itself as well.
--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Hi

An addition - when you want dates for 1 month only, then
=IF(MONTH(A1+1)=MONTH(A$1),A1+1,"")
and copy down for 30 rows (row 1 is 31th)


--
(When sending e-mail, use address (e-mail address removed))
Arvi Laanemets


A.W.J. Ales said:
Peta,

Assuming your date 21/01/2004 is in cell A1 in cell A2 just use =A1+1

In Excel a date is just a number (1-1-1900 =1 ; 2-1-1900 =2 etc.) so you can
do normal calculations with them.
Excel takes care of leap years itself as well.
--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
Click to expand...
 
peta
If you want a formula which won't display future dates try the following

=IF(A1="","",IF(A1+1>TODAY(),"",A1+1)

Good Luck
Mark Graesse
(e-mail address removed)

----- peta > wrote: ----

I'm creating a time sheet for which I do not want to have to manuall
enter the next days date, OK to start with a date but then use
formula to do the next cells sourcing from the previous cell

To look something like this

21/01/2004 (manual entering OK
22/01/2004 (require formula sourcing from above dat
23/01/2004 (as above... etc etc)*(B)21(/B)
 
Back
Top