days used in a formula

[Dav]

today() returns todays date

day(today()) returns the day of the month

weekday(today()) returns the weekday of the date

Regards

Dav

 

[Bob Phillips]

=SUM(E26:E99)/DAY(TODAY())

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Bondi]

does someone know how to insert the day of the month in a formula ?

example

=SUM(E26:E99)/here should be today's date

Thanks for any help

John-

Hi John,

If you mean insert the day number of the month you can use:

=SUM(E26:E99)/DAY(TODAY())

Regards,
Bondi

 

[Jean-Louis Indekeu]

does someone know how to insert the day of the month in a formula ?

example

=SUM(E26:E99)/here should be today's date

Thanks for any help

John-

 

[Jean-Louis Indekeu]

Thanks guys it woked perfectly as I wanted !!
Great