# Thread: off topic - solution for Excel date formula

1. ## off topic - solution for Excel date formula

User misha (mm_ke@yahoo.com) posted:

To get the last day of the month, letting Excel check
for leap years, etc. you can use this formula:

- get first day of next month (check for dec to jan)
- subtract one day to get last day of this month

=IF(MONTH(TODAY())<12,DATE(YEAR(TODAY()),1+MONTH(T ODAY()),1),DATE
(1+YEAR(TODAY()),1,1))-1

returns the Excel date number for the month's last day.
All that remains is formatting the cell...

To extend this idea, you could subtract the first day
of the month and get the number of days in the month:

=IF(MONTH(TODAY())<12,DATE(YEAR(TODAY()),1+MONTH(T ODAY()),1),DATE
(1+YEAR(TODAY()),1,1))-DATE(YEAR(TODAY()),MONTH(TODAY()),1)

returns 31 at the moment :-)

-- Misha.

multiple parameters.
to evaluate and depending on whether or not the month is Jan, July,
Aug, Oct, etc. put the date as the 31st of the month. I can only get
it to work if I use one month.
MONTH(TODAY()) & "/30/" &YEAR(TODAY()))
Tell us what you think! http://us.click.yahoo.com/vO1FAB/txz...SFAA/NhFolB/TM

2. ## Re: off topic - solution for Excel date formula

User (ssylve1445@mindspring.com) posted:

thanks. The solution worked perfectly. Apparently VLOOKUP does not work with QuickTest so that solution created another problem.

Stephanie
NetJuice Consulting

winrunner@yahoogroups.com wrote:
for leap years, etc. you can use this formula:

- get first day of next month (check for dec to jan)
- subtract one day to get last day of this month

=IF(MONTH(TODAY()) I have an excel formula that I am not sure how to get working with
multiple parameters.
to evaluate and depending on whether or not the month is Jan, July,
Aug, Oct, etc. put the date as the 31st of the month. I can only get
it to work if I use one month.
MONTH(TODAY()) & "/30/" &YEAR(TODAY()))

3. ## Re: off topic - solution for Excel date formula

Thans for this code. I think everyone one of us should post something similar. That is one way to lear from others. We should have something similar to "tip of the day" where people can post anything valuable or anthing thing that they discover during testing etc. so that we can all add that to our skill. Thans everydody!
aeulert

------------------

4. ## Re: off topic - solution for Excel date formula

User nmwinrunner (nmwinrunner@yahoo.com.nospam) posted:

Hi All,

Any body knows where can i find information or groups
for cste exams.

thanks,
nmwinrunner

__________________________________________________

5. ## Re: off topic - solution for Excel date formula

User ("Gopalan,SriramR.(CORP,Consultant)".nospam) posted:
www.qaiindia.com

6. ## Re: off topic - solution for Excel date formula

User rick holmes (qsarickh@yahoo.com.nospam) posted:

NM,

You can go to www.qaiusa.com, click the 'Federation
chapters' link. Find the chapter nearest you and
contact them. Most of them should have study groups or
at least have an exam scheduled.

Regards,

Rick J. Holmes

--- nmwinrunner <nmwinrunner@yahoo.com> wrote:

__________________________________________________

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•

vBulletin Optimisation provided by vB Optimise v2.6.0 Beta 4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.